<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%Session.CodePage=65001%>
<!--#include file="include/header.asp"-->
    <div id="content">
		<!--中间Start-->	
		<div id="centrepanel">
			<div id="panelbg"><a href="product.asp?pid=532"><img src="images/banners/653x84_DC3_banner.gif"  border=0 class="banner"></a></div>
			<div id="panelbg" style="overflow: visible; text-align: left; display: block;">
				<h1>X-Plane PC pilots can now join the cut-and-thrust world of freight flying! Air Hauler for X-Plane 9 will be released on the 25th March - pre-order now! </h1>								
				<%
				set rs = conn.execute("select top 1 B.* from pro_index as A left join Products as B on A.pid=B.id order by A.rank,A.id desc")
				if not rs.eof then
				%>
				<table cellpadding="5" width="100%">
					<tr>
						<td rowspan="3" valign="top" width="20%"><div style="vertical-align: top; margin: 15px 10px 20px 10px;"><a href="product.asp?pid=<%=rs("ID")%>"><img class="packshot" src="files/<%=rs("Img")%>"/></a></div></td>
						<td colspan="2" valign="bottom" height="13px"></td>
					</tr>
					<tr><td colspan="2" valign="top"><span style="font-size: 16px"><strong><%=rs("Title")%></strong></span></td></tr>
					<tr>
						<td valign="top" width="350">
						<p class="productpageJRtext">Download Size:   </p>
						<span class="productpageWasprice"> &pound;<%=rs("MarketPrice")%></span> <br />
						<span class="productpageprice">Now only</span>
						<span class="productpagepriceRed"> &pound;<%=rs("NowPrice")%> </span>
						<br /><br /><span class="productpagecompatibility">Compatibility: <%=rs("Sim")%></span><br /></td>
						<td align="right" valign="top">
						<div style="text-align: right; padding-right: 10px;">
						<div class="productpagebuydownload"><a href="#" ><img src="images/roundButtons/buyDownload.gif"  alt="Buy Download" /></a></div>					
						<br />
						<span style="padding-right: 5px;"><a href="product.asp?pid=<%=rs("ID")%>" ><img alt="more info" class="button" src="images/roundButtons/moreInfo.gif"  /></a> </span></div></td>
					</tr>

					<tr valign="top">
						<td colspan="3"><%=rs("Content")%></td>
					</tr>
				</table>	
				<%
				end if
				rs.close
				%>							
			</div>

			<div id="panelbg">
				<h1>新闻</h1><br />
				<%
				sql="select top 3 * from News order by rank,subdate desc"
				set rs = conn.execute(sql)
				for i=1 to 3
					if rs.eof then exit for
					if i=1 then
				%>
					<table width="100%">
						<tr>
							<td width="2%"></td> 
							<td width="79%"><b><%=rs("title")%><br /></td>
							<td valign="top" width="19%"><a href="news.asp" ><img align="right" class="marginbox" src="images/roundButtons/allNews.gif"  /></a></td>
						</tr>
						<tr>
							<td colspan="3"><%=rs("Content")%></td>
						</tr>
					</table>
					<div class="dashedbottom" style="width:653px;"></div>
				<%
					else					
				%>
						<div class="listresults" onclick="DoNav('newsDetail.asp?newsid=<%=rs("ID")%>');">
							<span class="listtitle"><a href="newsDetail.asp?newsid=<%=rs("ID")%>" ><%=rs("title")%></a></span>
							<div class="listsubhead"><%=rs("summary")%></div>
							<div class="listsubheaddate"><%=rs("subDate")%></div>
						</div>
					   <div class="dashedbottom" style="width:653px;"></div>
				<%
					end if
					rs.movenext
				next
				%>							
				<br />          
			</div>

			<div id="panelbg">
				<h1>Just a few of our recent releases...</h1><br />
				<table cellpadding="0" cellspacing="5" width="100%">
					<tr>
					<%
					sql="select top 3 * from Products order by Rank"
					set rs = conn.execute(sql)
					do while not rs.eof	
						if rs("NowPrice")<>0 then
							price=rs("NowPrice")
						else
							price=rs("MarketPrice")
						end if
					%>					
						<td align="center" valign="middle"><a href="product.asp?pid=<%=rs("ID")%>"><img src="files/<%=rs("Img")%>" border="0" class="packshot" /></a></td>
						<td><strong><a href="product.asp?pid=<%=rs("ID")%>"><%=rs("Title")%></a></strong><br />
						<br />
						<span class="productpagepricesml">&pound;<%=price%></span><br />
						<br />
						</td>
						<%
						rs.movenext
					loop
					%>
					</tr>
				</table>
				<div><a href="#BackToTop"><img alt="back to top" src="images/roundButtons/JFbacktotop.gif" class="button" align="right"/></a></div>
			</div>
			<!--#include file="include/bottomSide.asp"-->
			<br />
		</div>
		<!--中间End-->
		
		<!--左边Start-->	
		<!--#include file="include/leftSide.asp"-->
		<!--左边End-->	
		<!--右边Start-->	
		<!--#include file="include/rightSide.asp"-->
		<!--右边End-->
	</div>
</div>
<!--#include file="include/closeConn.asp"-->
</body>
</html>
